airquality_profiling

Dataset statistics

Number of variables	17
Number of observations	9471
Missing cells	37353
Missing cells (%)	23.2%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	1.2 MiB
Average record size in memory	136.0 B

Variable types

Categorical	2
Numeric	13
Unsupported	2

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`Date` has a high cardinality: 391 distinct values	High cardinality
`CO(GT)` is highly overall correlated with `PT08.S1(CO)` and 8 other fields	High correlation
`PT08.S1(CO)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`NMHC(GT)` is highly overall correlated with `CO(GT)` and 9 other fields	High correlation
`C6H6(GT)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`PT08.S2(NMHC)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`NOx(GT)` is highly overall correlated with `CO(GT)` and 7 other fields	High correlation
`PT08.S3(NOx)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`NO2(GT)` is highly overall correlated with `CO(GT)` and 7 other fields	High correlation
`PT08.S4(NO2)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`PT08.S5(O3)` is highly overall correlated with `CO(GT)` and 8 other fields	High correlation
`T` is highly overall correlated with `NMHC(GT)` and 3 other fields	High correlation
`RH` is highly overall correlated with `T`	High correlation
`AH` is highly overall correlated with `PT08.S4(NO2)` and 1 other fields	High correlation
`Date` has 114 (1.2%) missing values	Missing
`Time` has 114 (1.2%) missing values	Missing
`CO(GT)` has 1797 (19.0%) missing values	Missing
`PT08.S1(CO)` has 480 (5.1%) missing values	Missing
`NMHC(GT)` has 8557 (90.3%) missing values	Missing
`C6H6(GT)` has 480 (5.1%) missing values	Missing
`PT08.S2(NMHC)` has 480 (5.1%) missing values	Missing
`NOx(GT)` has 1753 (18.5%) missing values	Missing
`PT08.S3(NOx)` has 480 (5.1%) missing values	Missing
`NO2(GT)` has 1756 (18.5%) missing values	Missing
`PT08.S4(NO2)` has 480 (5.1%) missing values	Missing
`PT08.S5(O3)` has 480 (5.1%) missing values	Missing
`T` has 480 (5.1%) missing values	Missing
`RH` has 480 (5.1%) missing values	Missing
`AH` has 480 (5.1%) missing values	Missing
`Unnamed: 15` has 9471 (100.0%) missing values	Missing
`Unnamed: 16` has 9471 (100.0%) missing values	Missing
`Date` is uniformly distributed	Uniform
`Time` is uniformly distributed	Uniform
`Unnamed: 15` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Unnamed: 16` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-04-03 08:25:22.286209
Analysis finished	2023-04-03 08:25:50.127300
Duration	27.84 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Date
Categorical

HIGH CARDINALITY MISSING UNIFORM

Distinct	391
Distinct (%)	4.2%
Missing	114
Missing (%)	1.2%
Memory size	74.1 KiB

10/11/2004	24
02/12/2004	24
01/12/2004	24
30/11/2004	24
29/11/2004	24
Other values (386)	9237

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	93570
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10/03/2004
2nd row	10/03/2004
3rd row	10/03/2004
4th row	10/03/2004
5th row	10/03/2004

Common Values

Value	Count	Frequency (%)
10/11/2004	24	0.3%
02/12/2004	24	0.3%
01/12/2004	24	0.3%
30/11/2004	24	0.3%
29/11/2004	24	0.3%
28/11/2004	24	0.3%
27/11/2004	24	0.3%
26/11/2004	24	0.3%
25/11/2004	24	0.3%
24/11/2004	24	0.3%
Other values (381)	9117	96.3%
(Missing)	114	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
10/11/2004	24	0.3%
20/09/2004	24	0.3%
12/03/2004	24	0.3%
13/03/2004	24	0.3%
14/03/2004	24	0.3%
15/03/2004	24	0.3%
16/03/2004	24	0.3%
17/03/2004	24	0.3%
18/03/2004	24	0.3%
19/03/2004	24	0.3%
Other values (381)	9117	97.4%

Most occurring characters

Value	Count	Frequency (%)
0	30180	32.3%
/	18714	20.0%
2	14805	15.8%
4	8844	9.5%
1	7902	8.4%
5	3903	4.2%
3	2670	2.9%
8	1656	1.8%
7	1656	1.8%
6	1632	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	74856	80.0%
Other Punctuation	18714	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	30180	40.3%
2	14805	19.8%
4	8844	11.8%
1	7902	10.6%
5	3903	5.2%
3	2670	3.6%
8	1656	2.2%
7	1656	2.2%
6	1632	2.2%
9	1608	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	18714	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	93570	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	30180	32.3%
/	18714	20.0%
2	14805	15.8%
4	8844	9.5%
1	7902	8.4%
5	3903	4.2%
3	2670	2.9%
8	1656	1.8%
7	1656	1.8%
6	1632	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93570	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	30180	32.3%
/	18714	20.0%
2	14805	15.8%
4	8844	9.5%
1	7902	8.4%
5	3903	4.2%
3	2670	2.9%
8	1656	1.8%
7	1656	1.8%
6	1632	1.7%

Time
Categorical

MISSING UNIFORM

Distinct	24
Distinct (%)	0.3%
Missing	114
Missing (%)	1.2%
Memory size	74.1 KiB

18.00.00	390
05.00.00	390
14.00.00	390
13.00.00	390
12.00.00	390
Other values (19)	7407

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	74856
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	18.00.00
2nd row	19.00.00
3rd row	20.00.00
4th row	21.00.00
5th row	22.00.00

Common Values

Value	Count	Frequency (%)
18.00.00	390	4.1%
05.00.00	390	4.1%
14.00.00	390	4.1%
13.00.00	390	4.1%
12.00.00	390	4.1%
11.00.00	390	4.1%
10.00.00	390	4.1%
09.00.00	390	4.1%
08.00.00	390	4.1%
07.00.00	390	4.1%
Other values (14)	5457	57.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18.00.00	390	4.2%
06.00.00	390	4.2%
20.00.00	390	4.2%
21.00.00	390	4.2%
22.00.00	390	4.2%
23.00.00	390	4.2%
00.00.00	390	4.2%
01.00.00	390	4.2%
02.00.00	390	4.2%
03.00.00	390	4.2%
Other values (14)	5457	58.3%

Most occurring characters

Value	Count	Frequency (%)
0	42498	56.8%
.	18714	25.0%
1	5067	6.8%
2	2730	3.6%
3	1170	1.6%
8	780	1.0%
4	780	1.0%
9	780	1.0%
5	779	1.0%
7	779	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	56142	75.0%
Other Punctuation	18714	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	42498	75.7%
1	5067	9.0%
2	2730	4.9%
3	1170	2.1%
8	780	1.4%
4	780	1.4%
9	780	1.4%
5	779	1.4%
7	779	1.4%
6	779	1.4%

Other Punctuation

Value	Count	Frequency (%)
.	18714	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	74856	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	42498	56.8%
.	18714	25.0%
1	5067	6.8%
2	2730	3.6%
3	1170	1.6%
8	780	1.0%
4	780	1.0%
9	780	1.0%
5	779	1.0%
7	779	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	74856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	42498	56.8%
.	18714	25.0%
1	5067	6.8%
2	2730	3.6%
3	1170	1.6%
8	780	1.0%
4	780	1.0%
9	780	1.0%
5	779	1.0%
7	779	1.0%

CO(GT)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	96
Distinct (%)	1.3%
Missing	1797
Missing (%)	19.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1527495

Minimum	0.1
Maximum	11.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	0.1
5-th percentile	0.5
Q1	1.1
median	1.8
Q3	2.9
95-th percentile	4.9
Maximum	11.9
Range	11.8
Interquartile range (IQR)	1.8

Descriptive statistics

Standard deviation	1.453252
Coefficient of variation (CV)	0.67506786
Kurtosis	2.6677794
Mean	2.1527495
Median Absolute Deviation (MAD)	0.8
Skewness	1.3697528
Sum	16520.2
Variance	2.1119415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	305	3.2%
1.4	279	2.9%
1.6	275	2.9%
1.5	273	2.9%
1.1	262	2.8%
0.7	260	2.7%
1.7	258	2.7%
1.3	253	2.7%
0.8	251	2.7%
0.9	248	2.6%
Other values (86)	5010	52.9%
(Missing)	1797	19.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	33	0.3%
0.2	45	0.5%
0.3	98	1.0%
0.4	160	1.7%
0.5	217	2.3%
0.6	244	2.6%
0.7	260	2.7%
0.8	251	2.7%
0.9	248	2.6%
1	305	3.2%

Value	Count	Frequency (%)
11.9	1	< 0.1%
11.5	1	< 0.1%
10.2	2	< 0.1%
10.1	1	< 0.1%
9.9	1	< 0.1%
9.5	1	< 0.1%
9.4	1	< 0.1%
9.3	1	< 0.1%
9.2	1	< 0.1%
9.1	2	< 0.1%

PT08.S1(CO)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1041
Distinct (%)	11.6%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	1099.8332

Minimum	647
Maximum	2040
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	647
5-th percentile	810.5
Q1	937
median	1063
Q3	1231
95-th percentile	1508
Maximum	2040
Range	1393
Interquartile range (IQR)	294

Descriptive statistics

Standard deviation	217.08004
Coefficient of variation (CV)	0.19737542
Kurtosis	0.33512865
Mean	1099.8332
Median Absolute Deviation (MAD)	142
Skewness	0.75590737
Sum	9888600
Variance	47123.743
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
973	30	0.3%
1100	28	0.3%
988	26	0.3%
969	26	0.3%
925	26	0.3%
938	26	0.3%
966	25	0.3%
970	25	0.3%
984	25	0.3%
987	25	0.3%
Other values (1031)	8729	92.2%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
647	1	< 0.1%
649	1	< 0.1%
655	1	< 0.1%
667	3	< 0.1%
669	1	< 0.1%
676	1	< 0.1%
678	1	< 0.1%
679	1	< 0.1%
681	1	< 0.1%
683	2	< 0.1%

Value	Count	Frequency (%)
2040	1	< 0.1%
2008	1	< 0.1%
1982	1	< 0.1%
1975	1	< 0.1%
1973	1	< 0.1%
1961	1	< 0.1%
1956	1	< 0.1%
1934	1	< 0.1%
1918	1	< 0.1%
1917	1	< 0.1%

NMHC(GT)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	429
Distinct (%)	46.9%
Missing	8557
Missing (%)	90.3%
Infinite	0
Infinite (%)	0.0%
Mean	218.81182

Minimum	7
Maximum	1189
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	7
5-th percentile	28.65
Q1	67
median	150
Q3	297
95-th percentile	661.4
Maximum	1189
Range	1182
Interquartile range (IQR)	230

Descriptive statistics

Standard deviation	204.45992
Coefficient of variation (CV)	0.93440987
Kurtosis	2.270289
Mean	218.81182
Median Absolute Deviation (MAD)	94
Skewness	1.5570171
Sum	199994
Variance	41803.859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66	14	0.1%
40	9	0.1%
29	9	0.1%
88	8	0.1%
93	8	0.1%
84	7	0.1%
55	7	0.1%
95	7	0.1%
60	7	0.1%
57	7	0.1%
Other values (419)	831	8.8%
(Missing)	8557	90.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	2	< 0.1%
16	1	< 0.1%
17	4	< 0.1%
18	2	< 0.1%
19	2	< 0.1%

Value	Count	Frequency (%)
1189	1	< 0.1%
1129	1	< 0.1%
1084	1	< 0.1%
1042	1	< 0.1%
974	1	< 0.1%
926	1	< 0.1%
899	1	< 0.1%
880	1	< 0.1%
872	1	< 0.1%
840	1	< 0.1%

C6H6(GT)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	407
Distinct (%)	4.5%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	10.083105

Minimum	0.1
Maximum	63.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	0.1
5-th percentile	1.7
Q1	4.4
median	8.2
Q3	14
95-th percentile	24.65
Maximum	63.7
Range	63.6
Interquartile range (IQR)	9.6

Descriptive statistics

Standard deviation	7.4498197
Coefficient of variation (CV)	0.7388418
Kurtosis	2.4887059
Mean	10.083105
Median Absolute Deviation (MAD)	4.4
Skewness	1.3615323
Sum	90657.2
Variance	55.499814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.6	84	0.9%
2.8	82	0.9%
3.8	79	0.8%
4	78	0.8%
3.1	77	0.8%
3	76	0.8%
2.5	75	0.8%
2.9	73	0.8%
5.4	72	0.8%
2.2	71	0.7%
Other values (397)	8224	86.8%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	2	< 0.1%
0.2	8	0.1%
0.3	10	0.1%
0.4	14	0.1%
0.5	20	0.2%
0.6	23	0.2%
0.7	31	0.3%
0.8	25	0.3%
0.9	25	0.3%
1	30	0.3%

Value	Count	Frequency (%)
63.7	1	< 0.1%
52.1	1	< 0.1%
50.8	1	< 0.1%
50.7	1	< 0.1%
50.6	1	< 0.1%
49.5	1	< 0.1%
49.4	1	< 0.1%
48.2	1	< 0.1%
47.7	1	< 0.1%
47.5	1	< 0.1%

PT08.S2(NMHC)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1245
Distinct (%)	13.8%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	939.15338

Minimum	383
Maximum	2214
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	383
5-th percentile	562
Q1	734.5
median	909
Q3	1116
95-th percentile	1420
Maximum	2214
Range	1831
Interquartile range (IQR)	381.5

Descriptive statistics

Standard deviation	266.83143
Coefficient of variation (CV)	0.28411912
Kurtosis	0.063243873
Mean	939.15338
Median Absolute Deviation (MAD)	188
Skewness	0.56156598
Sum	8443928
Variance	71199.011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
853	25	0.3%
880	23	0.2%
800	23	0.2%
859	23	0.2%
985	22	0.2%
783	21	0.2%
769	21	0.2%
776	21	0.2%
850	21	0.2%
1012	20	0.2%
Other values (1235)	8771	92.6%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
383	2	< 0.1%
387	1	< 0.1%
388	1	< 0.1%
390	2	< 0.1%
397	1	< 0.1%
399	1	< 0.1%
402	2	< 0.1%
407	2	< 0.1%
408	1	< 0.1%
409	1	< 0.1%

Value	Count	Frequency (%)
2214	1	< 0.1%
2007	1	< 0.1%
1983	1	< 0.1%
1981	1	< 0.1%
1980	1	< 0.1%
1959	1	< 0.1%
1958	1	< 0.1%
1935	1	< 0.1%
1924	1	< 0.1%
1920	1	< 0.1%

NOx(GT)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	925
Distinct (%)	12.0%
Missing	1753
Missing (%)	18.5%
Infinite	0
Infinite (%)	0.0%
Mean	246.89673

Minimum	2
Maximum	1479
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	2
5-th percentile	38
Q1	98
median	180
Q3	326
95-th percentile	693
Maximum	1479
Range	1477
Interquartile range (IQR)	228

Descriptive statistics

Standard deviation	212.97917
Coefficient of variation (CV)	0.86262448
Kurtosis	3.4021344
Mean	246.89673
Median Absolute Deviation (MAD)	100
Skewness	1.7157808
Sum	1905549
Variance	45360.126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89	41	0.4%
65	37	0.4%
93	36	0.4%
122	36	0.4%
41	36	0.4%
132	35	0.4%
95	35	0.4%
180	35	0.4%
51	34	0.4%
120	34	0.4%
Other values (915)	7359	77.7%
(Missing)	1753	18.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
11	4	< 0.1%
12	4	< 0.1%
13	4	< 0.1%

Value	Count	Frequency (%)
1479	1	< 0.1%
1389	2	< 0.1%
1369	1	< 0.1%
1358	1	< 0.1%
1345	1	< 0.1%
1310	1	< 0.1%
1301	1	< 0.1%
1290	1	< 0.1%
1253	1	< 0.1%
1247	1	< 0.1%

PT08.S3(NOx)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1221
Distinct (%)	13.6%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	835.4936

Minimum	322
Maximum	2683
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	322
5-th percentile	483
Q1	658
median	806
Q3	969.5
95-th percentile	1291
Maximum	2683
Range	2361
Interquartile range (IQR)	311.5

Descriptive statistics

Standard deviation	256.81732
Coefficient of variation (CV)	0.30738394
Kurtosis	2.6775589
Mean	835.4936
Median Absolute Deviation (MAD)	155
Skewness	1.1017292
Sum	7511923
Variance	65955.136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
767	25	0.3%
733	25	0.3%
846	25	0.3%
765	23	0.2%
876	23	0.2%
685	22	0.2%
816	22	0.2%
891	22	0.2%
830	22	0.2%
845	22	0.2%
Other values (1211)	8760	92.5%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
322	1	< 0.1%
325	2	< 0.1%
328	1	< 0.1%
330	2	< 0.1%
334	1	< 0.1%
335	1	< 0.1%
340	2	< 0.1%
341	1	< 0.1%
345	1	< 0.1%
346	1	< 0.1%

Value	Count	Frequency (%)
2683	1	< 0.1%
2559	1	< 0.1%
2542	1	< 0.1%
2331	1	< 0.1%
2327	1	< 0.1%
2318	1	< 0.1%
2294	1	< 0.1%
2121	1	< 0.1%
2095	2	< 0.1%
2081	1	< 0.1%

NO2(GT)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	283
Distinct (%)	3.7%
Missing	1756
Missing (%)	18.5%
Infinite	0
Infinite (%)	0.0%
Mean	113.09125

Minimum	2
Maximum	340
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	2
5-th percentile	43
Q1	78
median	109
Q3	142
95-th percentile	200.3
Maximum	340
Range	338
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	48.370108
Coefficient of variation (CV)	0.42770866
Kurtosis	0.46503212
Mean	113.09125
Median Absolute Deviation (MAD)	32
Skewness	0.62171431
Sum	872499
Variance	2339.6673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
97	78	0.8%
117	77	0.8%
119	77	0.8%
95	75	0.8%
101	75	0.8%
114	75	0.8%
110	74	0.8%
115	73	0.8%
116	72	0.8%
107	72	0.8%
Other values (273)	6967	73.6%
(Missing)	1756	18.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
5	2	< 0.1%
7	1	< 0.1%
8	2	< 0.1%
9	2	< 0.1%
11	2	< 0.1%
12	2	< 0.1%
13	1	< 0.1%
14	5	0.1%

Value	Count	Frequency (%)
340	1	< 0.1%
333	1	< 0.1%
326	1	< 0.1%
322	1	< 0.1%
312	1	< 0.1%
310	1	< 0.1%
309	1	< 0.1%
306	1	< 0.1%
301	1	< 0.1%
296	1	< 0.1%

PT08.S4(NO2)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1603
Distinct (%)	17.8%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	1456.2646

Minimum	551
Maximum	2775
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	551
5-th percentile	883
Q1	1227
median	1463
Q3	1674
95-th percentile	2029
Maximum	2775
Range	2224
Interquartile range (IQR)	447

Descriptive statistics

Standard deviation	346.20679
Coefficient of variation (CV)	0.23773619
Kurtosis	0.078018624
Mean	1456.2646
Median Absolute Deviation (MAD)	221
Skewness	0.20538853
Sum	13093275
Variance	119859.14
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1488	24	0.3%
1580	22	0.2%
1539	21	0.2%
1467	20	0.2%
1638	19	0.2%
1490	18	0.2%
1418	18	0.2%
1321	17	0.2%
1511	17	0.2%
1473	17	0.2%
Other values (1593)	8798	92.9%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
551	1	< 0.1%
559	1	< 0.1%
561	1	< 0.1%
579	1	< 0.1%
601	1	< 0.1%
602	1	< 0.1%
605	1	< 0.1%
621	1	< 0.1%
637	1	< 0.1%
640	1	< 0.1%

Value	Count	Frequency (%)
2775	1	< 0.1%
2746	1	< 0.1%
2691	1	< 0.1%
2684	1	< 0.1%
2679	1	< 0.1%
2667	1	< 0.1%
2665	1	< 0.1%
2662	1	< 0.1%
2643	2	< 0.1%
2641	2	< 0.1%

PT08.S5(O3)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1743
Distinct (%)	19.4%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	1022.9061

Minimum	221
Maximum	2523
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	221
5-th percentile	461
Q1	731.5
median	963
Q3	1273.5
95-th percentile	1761.5
Maximum	2523
Range	2302
Interquartile range (IQR)	542

Descriptive statistics

Standard deviation	398.48429
Coefficient of variation (CV)	0.38956095
Kurtosis	0.078612339
Mean	1022.9061
Median Absolute Deviation (MAD)	261
Skewness	0.6278645
Sum	9196949
Variance	158789.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
836	20	0.2%
825	20	0.2%
826	19	0.2%
926	18	0.2%
799	17	0.2%
777	17	0.2%
949	16	0.2%
891	16	0.2%
923	16	0.2%
905	16	0.2%
Other values (1733)	8816	93.1%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
221	1	< 0.1%
225	1	< 0.1%
227	1	< 0.1%
232	1	< 0.1%
252	1	< 0.1%
253	1	< 0.1%
257	1	< 0.1%
261	2	< 0.1%
262	1	< 0.1%
263	1	< 0.1%

Value	Count	Frequency (%)
2523	1	< 0.1%
2522	1	< 0.1%
2519	1	< 0.1%
2515	1	< 0.1%
2494	1	< 0.1%
2480	1	< 0.1%
2475	1	< 0.1%
2465	1	< 0.1%
2452	1	< 0.1%
2434	1	< 0.1%

T
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	436
Distinct (%)	4.8%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	18.317829

Minimum	-1.9
Maximum	44.6
Zeros	1
Zeros (%)	< 0.1%
Negative	13
Negative (%)	0.1%
Memory size	74.1 KiB

Quantile statistics

Minimum	-1.9
5-th percentile	4.6
Q1	11.8
median	17.8
Q3	24.4
95-th percentile	34.5
Maximum	44.6
Range	46.5
Interquartile range (IQR)	12.6

Descriptive statistics

Standard deviation	8.8321157
Coefficient of variation (CV)	0.48215953
Kurtosis	-0.45627382
Mean	18.317829
Median Absolute Deviation (MAD)	6.3
Skewness	0.30935679
Sum	164695.6
Variance	78.006268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.8	57	0.6%
21.3	54	0.6%
13.8	51	0.5%
20.2	51	0.5%
12.3	49	0.5%
15.6	49	0.5%
12	49	0.5%
16.3	48	0.5%
19.8	48	0.5%
14.6	47	0.5%
Other values (426)	8488	89.6%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.9	1	< 0.1%
-1.4	1	< 0.1%
-1.3	2	< 0.1%
-1.2	1	< 0.1%
-1.1	1	< 0.1%
-0.6	2	< 0.1%
-0.5	1	< 0.1%
-0.3	1	< 0.1%
-0.2	1	< 0.1%
-0.1	2	< 0.1%

Value	Count	Frequency (%)
44.6	1	< 0.1%
44.3	1	< 0.1%
43.4	1	< 0.1%
43.1	1	< 0.1%
42.8	3	< 0.1%
42.7	1	< 0.1%
42.6	1	< 0.1%
42.5	1	< 0.1%
42.2	2	< 0.1%
42	2	< 0.1%

RH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	753
Distinct (%)	8.4%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	49.234201

Minimum	9.2
Maximum	88.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	9.2
5-th percentile	20.3
Q1	35.8
median	49.6
Q3	62.5
95-th percentile	77.9
Maximum	88.7
Range	79.5
Interquartile range (IQR)	26.7

Descriptive statistics

Standard deviation	17.316892
Coefficient of variation (CV)	0.35172486
Kurtosis	-0.81837452
Mean	49.234201
Median Absolute Deviation (MAD)	13.3
Skewness	-0.03792801
Sum	442664.7
Variance	299.87476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.1	31	0.3%
47.8	30	0.3%
57.9	30	0.3%
60.8	27	0.3%
45.9	27	0.3%
43.4	26	0.3%
50.9	26	0.3%
49.8	26	0.3%
50.1	26	0.3%
50.8	26	0.3%
Other values (743)	8716	92.0%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.2	2	< 0.1%
9.3	1	< 0.1%
9.6	1	< 0.1%
9.8	1	< 0.1%
9.9	2	< 0.1%
10	2	< 0.1%
10.2	1	< 0.1%
10.4	1	< 0.1%
10.7	1	< 0.1%
10.9	1	< 0.1%

Value	Count	Frequency (%)
88.7	1	< 0.1%
87.2	1	< 0.1%
87.1	1	< 0.1%
87	1	< 0.1%
86.6	2	< 0.1%
86.5	2	< 0.1%
86	1	< 0.1%
85.7	3	< 0.1%
85.6	1	< 0.1%
85.5	1	< 0.1%

AH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6683
Distinct (%)	74.3%
Missing	480
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.0255303

Minimum	0.1847
Maximum	2.231
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	74.1 KiB

Quantile statistics

Minimum	0.1847
5-th percentile	0.40085
Q1	0.7368
median	0.9954
Q3	1.3137
95-th percentile	1.7256
Maximum	2.231
Range	2.0463
Interquartile range (IQR)	0.5769

Descriptive statistics

Standard deviation	0.40381261
Coefficient of variation (CV)	0.39375981
Kurtosis	-0.56009784
Mean	1.0255303
Median Absolute Deviation (MAD)	0.2861
Skewness	0.25138776
Sum	9220.5427
Variance	0.16306462
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7487	6	0.1%
0.8394	6	0.1%
0.9684	6	0.1%
0.9722	6	0.1%
1.1199	6	0.1%
0.8325	5	0.1%
0.8736	5	0.1%
0.6686	5	0.1%
1.0594	5	0.1%
0.9271	5	0.1%
Other values (6673)	8936	94.4%
(Missing)	480	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1847	1	< 0.1%
0.1862	1	< 0.1%
0.191	1	< 0.1%
0.1975	1	< 0.1%
0.1988	1	< 0.1%
0.2029	1	< 0.1%
0.2031	1	< 0.1%
0.2062	1	< 0.1%
0.2086	1	< 0.1%
0.2157	1	< 0.1%

Value	Count	Frequency (%)
2.231	1	< 0.1%
2.1806	1	< 0.1%
2.1766	1	< 0.1%
2.1719	1	< 0.1%
2.1395	1	< 0.1%
2.1362	1	< 0.1%
2.1247	1	< 0.1%
2.1195	1	< 0.1%
2.117	1	< 0.1%
2.1164	1	< 0.1%

Unnamed: 15
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	9471
Missing (%)	100.0%
Memory size	74.1 KiB

Unnamed: 16
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	9471
Missing (%)	100.0%
Memory size	74.1 KiB

Auto

Heatmap
Table

	CO(GT)	PT08.S1(CO)	NMHC(GT)	C6H6(GT)	PT08.S2(NMHC)	NOx(GT)	PT08.S3(NOx)	NO2(GT)	PT08.S4(NO2)	PT08.S5(O3)	T	RH	AH	Time
CO(GT)	1.000	0.879	0.936	0.927	0.927	0.785	-0.811	0.735	0.594	0.856	0.069	-0.006	0.053	0.232
PT08.S1(CO)	0.879	1.000	0.851	0.889	0.889	0.725	-0.854	0.673	0.646	0.894	0.081	0.092	0.138	0.207
NMHC(GT)	0.936	0.851	1.000	0.950	0.950	0.884	-0.950	0.842	0.895	0.804	0.506	-0.278	0.293	0.244
C6H6(GT)	0.927	0.889	0.950	1.000	1.000	0.705	-0.850	0.669	0.749	0.874	0.276	-0.122	0.192	0.230
PT08.S2(NMHC)	0.927	0.889	0.950	1.000	1.000	0.705	-0.850	0.669	0.749	0.874	0.276	-0.122	0.192	0.255
NOx(GT)	0.785	0.725	0.884	0.705	0.705	1.000	-0.790	0.835	0.160	0.793	-0.283	0.182	-0.190	0.151
PT08.S3(NOx)	-0.811	-0.854	-0.950	-0.850	-0.850	-0.790	1.000	-0.689	-0.536	-0.862	-0.118	-0.084	-0.217	0.180
NO2(GT)	0.735	0.673	0.842	0.669	0.669	0.835	-0.689	1.000	0.154	0.709	-0.190	-0.121	-0.323	0.213
PT08.S4(NO2)	0.594	0.646	0.895	0.749	0.749	0.160	-0.536	0.154	1.000	0.561	0.614	-0.066	0.645	0.173
PT08.S5(O3)	0.856	0.894	0.804	0.874	0.874	0.793	-0.862	0.709	0.561	1.000	-0.002	0.128	0.083	0.170
T	0.069	0.081	0.506	0.276	0.276	-0.283	-0.118	-0.190	0.614	-0.002	1.000	-0.543	0.701	0.157
RH	-0.006	0.092	-0.278	-0.122	-0.122	0.182	-0.084	-0.121	-0.066	0.128	-0.543	1.000	0.156	0.196
AH	0.053	0.138	0.293	0.192	0.192	-0.190	-0.217	-0.323	0.645	0.083	0.701	0.156	1.000	0.000
Time	0.232	0.207	0.244	0.230	0.255	0.151	0.180	0.213	0.173	0.170	0.157	0.196	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Date	Time	CO(GT)	PT08.S1(CO)	NMHC(GT)	C6H6(GT)	PT08.S2(NMHC)	NOx(GT)	PT08.S3(NOx)	NO2(GT)	PT08.S4(NO2)	PT08.S5(O3)	T	RH	AH	Unnamed: 15	Unnamed: 16
0	10/03/2004	18.00.00	2.6	1360.0	150.0	11.9	1046.0	166.0	1056.0	113.0	1692.0	1268.0	13.6	48.9	0.7578	NaN	NaN
1	10/03/2004	19.00.00	2.0	1292.0	112.0	9.4	955.0	103.0	1174.0	92.0	1559.0	972.0	13.3	47.7	0.7255	NaN	NaN
2	10/03/2004	20.00.00	2.2	1402.0	88.0	9.0	939.0	131.0	1140.0	114.0	1555.0	1074.0	11.9	54.0	0.7502	NaN	NaN
3	10/03/2004	21.00.00	2.2	1376.0	80.0	9.2	948.0	172.0	1092.0	122.0	1584.0	1203.0	11.0	60.0	0.7867	NaN	NaN
4	10/03/2004	22.00.00	1.6	1272.0	51.0	6.5	836.0	131.0	1205.0	116.0	1490.0	1110.0	11.2	59.6	0.7888	NaN	NaN
5	10/03/2004	23.00.00	1.2	1197.0	38.0	4.7	750.0	89.0	1337.0	96.0	1393.0	949.0	11.2	59.2	0.7848	NaN	NaN
6	11/03/2004	00.00.00	1.2	1185.0	31.0	3.6	690.0	62.0	1462.0	77.0	1333.0	733.0	11.3	56.8	0.7603	NaN	NaN
7	11/03/2004	01.00.00	1.0	1136.0	31.0	3.3	672.0	62.0	1453.0	76.0	1333.0	730.0	10.7	60.0	0.7702	NaN	NaN
8	11/03/2004	02.00.00	0.9	1094.0	24.0	2.3	609.0	45.0	1579.0	60.0	1276.0	620.0	10.7	59.7	0.7648	NaN	NaN
9	11/03/2004	03.00.00	0.6	1010.0	19.0	1.7	561.0	NaN	1705.0	NaN	1235.0	501.0	10.3	60.2	0.7517	NaN	NaN

	Date	Time	CO(GT)	PT08.S1(CO)	NMHC(GT)	C6H6(GT)	PT08.S2(NMHC)	NOx(GT)	PT08.S3(NOx)	NO2(GT)	PT08.S4(NO2)	PT08.S5(O3)	T	RH	AH	Unnamed: 15	Unnamed: 16
9461	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9462	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9463	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9464	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9465	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9466	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9467	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9468	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9469	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9470	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	Date	Time	CO(GT)	PT08.S1(CO)	NMHC(GT)	C6H6(GT)	PT08.S2(NMHC)	NOx(GT)	PT08.S3(NOx)	NO2(GT)	PT08.S4(NO2)	PT08.S5(O3)	T	RH	AH	# duplicates
0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	114

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring